Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
ItemID (FK)(PK) | A unique system assigned identifier for the retailer's SKU. | ID_ITM | IdentityUUID | char(32) | |
SizeFamilyID (FK) | A unique retailer assigned idendtifier for the grouping of similar colors used to classify the sizes of merchandise for analysis. | ID_SZ_FMY | Identity | integer | Size(CO_SZ) |
SizeCode (FK) | A code to designate the size of the ITEM. It is proposed to use the 5 apparel and miscellaneous coding structure as specified by the NRMA to facilitate data interchange between vendors and retailers. This code permits the use of both standard and proprietary coding format. | CD_SZ | Code6 | char(6) | Size(CO_SZ) |
StyleCode (FK) | A code that uniquely identifies the specific appearance type or variety in which an APPAREL ITEM is available. | LU_STYL | Code4 | char(4) | Style(CO_STYL) |
ColorCode (FK) | A code to identify the color. The assumption is that the retailer will adopt the standards as designated by the NRF, created to facilitate the exchange of data between vendors and retailers | CD_CLR | Code4 | char(4) | Color(CO_CLR) |
Counting (FK) | The code used to specify the units in which a value is being expressed, or manner in which a measurement has been taken. This code relates to the UCC data element 355. | CD_UOM_RTL_SL_UN | Code | varchar(20) | UnitOfMeasure(CO_UOM) |
StockItemTypeCode | A retailer assigned code to indicate the StockItem type, ie ShelfItem, ApparelItem, SerializedItem, etc. | TY_ITM_STK | Code2 | char(2) | |
SaleWeightOrUnitCountCode | A retailer assigned code that indicates whether the StockItem is sold by weight or as an unit. | LU_CNT_SLS_WT_UN | Code2 | char(2) | |
CustomerPickupTypeCode | A retailer assigned code that defines where and how a customer may pickup this item. For examples a refrigerator may have to be picked up at the shipping dock or at the retailers warehouse. | TY_PKP_CT_STK_ITM | Code2 | char(2) | |
UnitPriceFactor | The number of units of measure per selling unit. Used as the divisor when calculating the STOCK ITEM's unit retail price, eg $1.67 per pound or $2.59 for 32 floz. | FA_PRC_UN_STK_ITM | Quantity | DECIMAL(9,3) | |
AvailableForSaleDate | The date when this STOCK ITEM becomes available for sale. For example, certain books have specific publication dates, music entertainment release dates. | DC_AVLB_FR_SLS | DateCalendar | date | |
EnvironmentTypeCode | A retailer assigned code that defines the temperature, relative humidity, lighting and other physical or climatic environmental requirements for storing and displaying the item. | TY_ENV_STK_ITM | Code2 | char(2) | |
SecurityRequiredTypeCode | A retailer assigned code that defines the security environment and procedures required for receiving, displaying and selling the item. This is for high-priced merchandise like jewelry, certain prescription drugs, ordinance, fireworks, etc. | TY_SCTY_RQ | Code2 | char(2) | |
HazardousMaterialTypeCode | A retailer assigned code that defines the relevant hazardous material handling properties of the item. This code is provided for oil products, petsicides, swimming pool suppliers, fertilizers (especially bomb grade), etc. | TY_MTR_HZ_STK_ITM | Code2 | char(2) | |
InventoryAccountingMethodCode | A retailer assigned code that defines the inventory accounting method to be used for the item. Examples of methods include the retail method, cost method, etc. | LU_MTH_INV_ACNT | Code2 | char(2) | |
SellUnitLastReceivedBaseCostAmount | The base cost per sell unit derived from the last receipt of this item. The base cost excludes allowances, discounts, charges and other amounts that may change the item cost. | CP_UN_SL_LS_RCV_BS | MoneyShortCost | decimal(16,5) | |
SellUnitLastReceivedNetCostAmount | The net cost per sell unit derived from the last receipt of this item. The base cost includes allowances, discounts, charges and other amounts that may change the item cost. Where there are no allowances, etc. the net cost will equal the base cost for an item. | CP_CST_NT_LS_RCV | MoneyShortCost | decimal(16,5) | |
SellUnitLandedCostAmount | The cost of the item plus the insurance, drayage, cartage, delivery, insurance, customs duties, etc. which add up to the full delivered cost of an imported item to the store. | CP_UN_SL_LND | MoneyShortCost | decimal(16,5) | |
SellUnitLastReceivedCostsEstablishedDate | The date the last received costs (net and base) were established. | DC_CST_EST_LS_RCV | DateCalendar | date | |
ShrinkFlag | A flad to denote if the STOCK ITEM could loose weight from the time of order until the time of receipt. | FL_SHRK_SH_ITM | Flag | integer | |
SwellFlag | A flag used to indicate if the STOCK ITEM may gain weight or swell from time of order to time of receipt. | FL_SWL_SH_ITM | Flag | integer | |
RetailPackageSize (FK) | The code used to specify the units in which a value is being expressed, or manner in which a measurement has been taken. This code relates to the UCC data element 355. | CD_UOM_RTL_PKG_SZ | Code | varchar(20) | UnitOfMeasure(CO_UOM) |